Most Powerful Open Source ERP

Developer Documentation

20- 12 2022

How To Search Portal Catalog

How To showing a tool that indexes all documents in a site, making it easy to search for documents.
Categories index ; search ; portal catalog ; MySQL
15- 07 2019

Guideline ZSQL Method Is Lowercase And Uses Z Prefix And Underscore Separator

For consistent naming.
Categories rule ; program ; portal catalog ; sql
15- 07 2019

Guideline SQL Column Id Is Lowercase

To ensure consistency in SQL tables.
Categories rule ; program ; portal catalog ; sql
06- 04 2017

Guideline SQL Column Id Use Singular For Related Key

To ensure consistent SQL naming.
Categories rule ; program ; sql ; portal catalog ; key
28- 06 2016

Technical Note on Catalog Uid Handling

Specifications of catalog uid handling
Categories catalog ; portal catalog ; search
16- 05 2016

Quick Search Area

How the Quick Search Area works.
Categories search ; fulltext ; portal catalog
22- 04 2016

Technical Note on SQL Catalog Structure

showing the structure of the portal catalog SQL tables used in ERP5.
Categories MySQL ; catalog ; search ; portal catalog
15- 02 2016

How To Edit Listbox Data Source

showing different ways to display data in a listbox from predicate to running custom catalog queries.
Categories listbox ; form ; predicate ; portal catalog
11- 02 2016

How To Add Custom Table to SQL Catalog

showing how to add custom tables to the SQL Catalog to more easily search for custom properties.
Categories table ; search ; portal catalog ; MySQL
09- 02 2016

How To Create Related Keys

How To showing how to extend the CatalogTool from ERP5Catalog to add new search keys.
Categories search ; related key ; portal catalog ; MySQL